Dataset statistics
| Number of variables | 21 |
|---|---|
| Number of observations | 2117035 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 1.8 GiB |
| Average record size in memory | 912.8 B |
Variable types
| Numeric | 8 |
|---|---|
| DateTime | 1 |
| Categorical | 12 |
store_name has a high cardinality: 1560 distinct values | High cardinality |
deposit/distributor has a high cardinality: 73 distinct values | High cardinality |
municipality/city has a high cardinality: 310 distinct values | High cardinality |
sku is highly correlated with unit_price and 1 other fields | High correlation |
units is highly correlated with total and 1 other fields | High correlation |
unit_price is highly correlated with sku and 1 other fields | High correlation |
unit_margin is highly correlated with sku and 1 other fields | High correlation |
total is highly correlated with units and 1 other fields | High correlation |
total_margin is highly correlated with units and 1 other fields | High correlation |
sku is highly correlated with unit_price and 1 other fields | High correlation |
units is highly correlated with total and 1 other fields | High correlation |
unit_price is highly correlated with sku and 1 other fields | High correlation |
unit_margin is highly correlated with sku and 1 other fields | High correlation |
total is highly correlated with units and 1 other fields | High correlation |
total_margin is highly correlated with units and 1 other fields | High correlation |
units is highly correlated with total and 1 other fields | High correlation |
unit_price is highly correlated with unit_margin | High correlation |
unit_margin is highly correlated with unit_price | High correlation |
total is highly correlated with units and 1 other fields | High correlation |
total_margin is highly correlated with units and 1 other fields | High correlation |
division is highly correlated with grade and 3 other fields | High correlation |
sku_subcategory is highly correlated with sku_description and 1 other fields | High correlation |
format is highly correlated with supplier | High correlation |
grade is highly correlated with division and 3 other fields | High correlation |
supplier is highly correlated with format | High correlation |
sku_description is highly correlated with sku_subcategory and 1 other fields | High correlation |
state is highly correlated with division and 3 other fields | High correlation |
structure is highly correlated with division and 3 other fields | High correlation |
sku_category is highly correlated with sku_subcategory and 1 other fields | High correlation |
deposit/distributor is highly correlated with division and 3 other fields | High correlation |
store_id is highly correlated with format and 2 other fields | High correlation |
format is highly correlated with store_id and 2 other fields | High correlation |
structure is highly correlated with division and 3 other fields | High correlation |
division is highly correlated with structure and 3 other fields | High correlation |
deposit/distributor is highly correlated with store_id and 5 other fields | High correlation |
state is highly correlated with structure and 3 other fields | High correlation |
supplier is highly correlated with store_id and 1 other fields | High correlation |
grade is highly correlated with structure and 3 other fields | High correlation |
sku is highly correlated with sku_description and 4 other fields | High correlation |
sku_description is highly correlated with sku and 5 other fields | High correlation |
sku_category is highly correlated with sku and 5 other fields | High correlation |
sku_subcategory is highly correlated with sku and 5 other fields | High correlation |
units is highly correlated with sku_description and 5 other fields | High correlation |
unit_price is highly correlated with sku and 4 other fields | High correlation |
unit_margin is highly correlated with sku and 5 other fields | High correlation |
total is highly correlated with units and 1 other fields | High correlation |
total_margin is highly correlated with units and 1 other fields | High correlation |
id has unique values | Unique |
Reproduction
| Analysis started | 2021-10-17 16:00:58.987346 |
|---|---|
| Analysis finished | 2021-10-17 16:03:46.338073 |
| Duration | 2 minutes and 47.35 seconds |
| Software version | pandas-profiling v3.1.0 |
| Download configuration | config.json |
| Distinct | 2117035 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1249979.587 |
| Minimum | 0 |
|---|---|
| Maximum | 2501729 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 24.2 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 123203.7 |
| Q1 | 622100.5 |
| median | 1250273 |
| Q3 | 1878664.5 |
| 95-th percentile | 2377093.3 |
| Maximum | 2501729 |
| Range | 2501729 |
| Interquartile range (IQR) | 1256564 |
Descriptive statistics
| Standard deviation | 723773.447 |
|---|---|
| Coefficient of variation (CV) | 0.5790282134 |
| Kurtosis | -1.205380782 |
| Mean | 1249979.587 |
| Median Absolute Deviation (MAD) | 628288 |
| Skewness | 0.000768806663 |
| Sum | 2.646250535 × 1012 |
| Variance | 5.238480026 × 1011 |
| Monotonicity | Strictly increasing |
| Value | Count | Frequency (%) |
| 2047 | 1 | < 0.1% |
| 2143932 | 1 | < 0.1% |
| 2201240 | 1 | < 0.1% |
| 2203289 | 1 | < 0.1% |
| 2197146 | 1 | < 0.1% |
| 2199195 | 1 | < 0.1% |
| 2209436 | 1 | < 0.1% |
| 2205342 | 1 | < 0.1% |
| 2121377 | 1 | < 0.1% |
| 2115234 | 1 | < 0.1% |
| Other values (2117025) | 2117025 |
| Value | Count | Frequency (%) |
| 0 | 1 | |
| 1 | 1 | |
| 2 | 1 | |
| 4 | 1 | |
| 5 | 1 | |
| 8 | 1 | |
| 9 | 1 | |
| 10 | 1 | |
| 11 | 1 | |
| 13 | 1 |
| Value | Count | Frequency (%) |
| 2501729 | 1 | |
| 2501728 | 1 | |
| 2501726 | 1 | |
| 2501725 | 1 | |
| 2501724 | 1 | |
| 2501723 | 1 | |
| 2501722 | 1 | |
| 2501720 | 1 | |
| 2501719 | 1 | |
| 2501718 | 1 |
date
Date
| Distinct | 446 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 32.3 MiB |
| Minimum | 2016-01-02 00:00:00 |
|---|---|
| Maximum | 2017-12-05 00:00:00 |
| Distinct | 1591 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2653.210929 |
| Minimum | 2 |
|---|---|
| Maximum | 5855 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 32.3 MiB |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 166 |
| Q1 | 1640 |
| median | 2734 |
| Q3 | 3785 |
| 95-th percentile | 5443 |
| Maximum | 5855 |
| Range | 5853 |
| Interquartile range (IQR) | 2145 |
Descriptive statistics
| Standard deviation | 1375.886199 |
|---|---|
| Coefficient of variation (CV) | 0.518573998 |
| Kurtosis | -0.4108450181 |
| Mean | 2653.210929 |
| Median Absolute Deviation (MAD) | 1060 |
| Skewness | 0.07630074236 |
| Sum | 5616940400 |
| Variance | 1893062.833 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 240 | 4410 | 0.2% |
| 3809 | 4256 | 0.2% |
| 1044 | 3964 | 0.2% |
| 3846 | 3949 | 0.2% |
| 3842 | 3939 | 0.2% |
| 2382 | 3925 | 0.2% |
| 3812 | 3919 | 0.2% |
| 3813 | 3820 | 0.2% |
| 5855 | 3772 | 0.2% |
| 3821 | 3769 | 0.2% |
| Other values (1581) | 2077312 |
| Value | Count | Frequency (%) |
| 2 | 930 | |
| 4 | 581 | |
| 5 | 544 | |
| 6 | 657 | |
| 7 | 454 | |
| 8 | 316 | < 0.1% |
| 9 | 892 | |
| 10 | 276 | < 0.1% |
| 11 | 366 | < 0.1% |
| 12 | 307 | < 0.1% |
| Value | Count | Frequency (%) |
| 5855 | 3772 | |
| 5851 | 1133 | 0.1% |
| 5850 | 1714 | |
| 5844 | 899 | < 0.1% |
| 5843 | 1482 | 0.1% |
| 5827 | 1666 | |
| 5825 | 2324 | |
| 5817 | 3211 | |
| 5815 | 2408 | |
| 5813 | 3276 |
| Distinct | 10 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 147.0 MiB |
| Grocery | |
|---|---|
| AllInOne | |
| Leftorium | |
| GipsyTrade | |
| Shop | |
| Other values (5) | 48517 |
Length
| Max length | 11 |
|---|---|
| Median length | 8 |
| Mean length | 7.8059777 |
| Min length | 4 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Grocery |
|---|---|
| 2nd row | Leftorium |
| 3rd row | Leftorium |
| 4th row | Grocery |
| 5th row | Leftorium |
Common Values
| Value | Count | Frequency (%) |
| Grocery | 655581 | |
| AllInOne | 622612 | |
| Leftorium | 404589 | |
| GipsyTrade | 223873 | 10.6% |
| Shop | 161863 | 7.6% |
| GreatShop | 37222 | 1.8% |
| TinyShop | 7812 | 0.4% |
| SmallShop | 3145 | 0.1% |
| Center | 287 | < 0.1% |
| SuperMarket | 51 | < 0.1% |
Length
Pie chart
| Value | Count | Frequency (%) |
| grocery | 655581 | |
| allinone | 622612 | |
| leftorium | 404589 | |
| gipsytrade | 223873 | 10.6% |
| shop | 161863 | 7.6% |
| greatshop | 37222 | 1.8% |
| tinyshop | 7812 | 0.4% |
| smallshop | 3145 | 0.1% |
| center | 287 | < 0.1% |
| supermarket | 51 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 1560 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 173.9 MiB |
| Last Golden Convenience | 5043 |
|---|---|
| Bloody Chocolate AllInOne | 4787 |
| Short Olive BigCom | 4730 |
| Dull Navy BookShop | 4410 |
| Empty Grey HairDresser | 4256 |
| Other values (1555) |
Length
| Max length | 32 |
|---|---|
| Median length | 21 |
| Mean length | 21.14351062 |
| Min length | 10 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 4 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Bizarre Salmon Market |
|---|---|
| 2nd row | Young Khaki TallMarket |
| 3rd row | Big Salmon Deli |
| 4th row | Bad Crimson Shop |
| 5th row | Kicking Lemon LunchHall |
Common Values
| Value | Count | Frequency (%) |
| Last Golden Convenience | 5043 | 0.2% |
| Bloody Chocolate AllInOne | 4787 | 0.2% |
| Short Olive BigCom | 4730 | 0.2% |
| Dull Navy BookShop | 4410 | 0.2% |
| Empty Grey HairDresser | 4256 | 0.2% |
| Awesome Yellow Stationer | 4151 | 0.2% |
| Kicking Brown Convenience | 4063 | 0.2% |
| Dead Lemon Tobacconist | 3964 | 0.2% |
| Bizarre Salmon BookShop | 3949 | 0.2% |
| Angry Green Laundrette | 3939 | 0.2% |
| Other values (1550) | 2073743 |
Length
| Value | Count | Frequency (%) |
| green | 122729 | 1.9% |
| blue | 110863 | 1.7% |
| shop | 81388 | 1.3% |
| stationer | 79612 | 1.2% |
| fishmonger | 77711 | 1.2% |
| florist | 76485 | 1.2% |
| young | 76140 | 1.2% |
| deli | 75790 | 1.2% |
| mall | 74590 | 1.2% |
| tallmarket | 74585 | 1.2% |
| Other values (102) | 5563907 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 144.9 MiB |
| METRO | |
|---|---|
| FORANEO | |
| DISTRIBUIDORES |
Length
| Max length | 14 |
|---|---|
| Median length | 5 |
| Mean length | 6.772356621 |
| Min length | 5 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | FORANEO |
|---|---|
| 2nd row | METRO |
| 3rd row | METRO |
| 4th row | METRO |
| 5th row | FORANEO |
Common Values
| Value | Count | Frequency (%) |
| METRO | 1135001 | |
| FORANEO | 726595 | |
| DISTRIBUIDORES | 255439 | 12.1% |
Length
Pie chart
| Value | Count | Frequency (%) |
| metro | 1135001 | |
| foraneo | 726595 | |
| distribuidores | 255439 | 12.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 11 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 157.8 MiB |
| METRO-NORTE | |
|---|---|
| METRO-SUR | |
| CENTRO | |
| BAJÍO | |
| CENTRO-SUR | |
| Other values (6) |
Length
| Max length | 11 |
|---|---|
| Median length | 9 |
| Mean length | 8.709758696 |
| Min length | 5 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | BAJÍO |
|---|---|
| 2nd row | METRO-NORTE |
| 3rd row | METRO-SUR |
| 4th row | METRO-NORTE |
| 5th row | BAJÍO |
Common Values
| Value | Count | Frequency (%) |
| METRO-NORTE | 597048 | |
| METRO-SUR | 537953 | |
| CENTRO | 233276 | 11.0% |
| BAJÍO | 220487 | 10.4% |
| CENTRO-SUR | 128802 | 6.1% |
| OCCIDENTE | 117924 | 5.6% |
| SURESTE | 94048 | 4.4% |
| PENÍNSULA | 72708 | 3.4% |
| NORESTE | 52688 | 2.5% |
| SUROESTE | 34513 | 1.6% |
Length
| Value | Count | Frequency (%) |
| metro-norte | 597048 | |
| metro-sur | 537953 | |
| centro | 233276 | 11.0% |
| bajío | 220487 | 10.4% |
| centro-sur | 128802 | 6.1% |
| occidente | 117924 | 5.6% |
| sureste | 94048 | 4.4% |
| península | 72708 | 3.4% |
| noreste | 52688 | 2.5% |
| suroeste | 34513 | 1.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 73 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 168.1 MiB |
| Emolor Vocals | |
|---|---|
| Lorthogus Toughworks | |
| Thrilthoal Empire | |
| Thrilvitar Industrail | 124420 |
| Ioalfio Ifonforge Industries | 120507 |
| Other values (68) |
Length
| Max length | 32 |
|---|---|
| Median length | 17 |
| Mean length | 18.26221012 |
| Min length | 12 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Argule Ifonforge Industries |
|---|---|
| 2nd row | Emolor Vocals |
| 3rd row | Thrilthoal Empire |
| 4th row | Lorthogus Toughworks |
| 5th row | Argule Ifonforge Industries |
Common Values
| Value | Count | Frequency (%) |
| Emolor Vocals | 285854 | 13.5% |
| Lorthogus Toughworks | 154174 | 7.3% |
| Thrilthoal Empire | 153812 | 7.3% |
| Thrilvitar Industrail | 124420 | 5.9% |
| Ioalfio Ifonforge Industries | 120507 | 5.7% |
| Thrilvallor Corp. | 103629 | 4.9% |
| Argule Ifonforge Industries | 84057 | 4.0% |
| Rusrusmo Toughworks | 80754 | 3.8% |
| Erodmad Industrail | 72370 | 3.4% |
| Elortho Aerospace | 71482 | 3.4% |
| Other values (63) | 865976 |
Length
| Value | Count | Frequency (%) |
| vocals | 502748 | 11.0% |
| industries | 320214 | 7.0% |
| ifonforge | 320214 | 7.0% |
| emolor | 285854 | 6.3% |
| toughworks | 285280 | 6.3% |
| industrail | 270849 | 5.9% |
| empire | 235293 | 5.2% |
| corp | 212078 | 4.7% |
| lorthogus | 154174 | 3.4% |
| thrilthoal | 153812 | 3.4% |
| Other values (72) | 1813768 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 29 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 147.9 MiB |
| Alloralf | |
|---|---|
| Magornmar | |
| Lorvalmo | |
| Thrilvallor | |
| Erodmo | |
| Other values (24) |
Length
| Max length | 11 |
|---|---|
| Median length | 8 |
| Mean length | 8.266879386 |
| Min length | 5 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Lorvalmo |
|---|---|
| 2nd row | Magornmar |
| 3rd row | Magornmar |
| 4th row | Alloralf |
| 5th row | Lorvalmo |
Common Values
| Value | Count | Frequency (%) |
| Alloralf | 691507 | |
| Magornmar | 554462 | |
| Lorvalmo | 92626 | 4.4% |
| Thrilvallor | 90364 | 4.3% |
| Erodmo | 77317 | 3.7% |
| Egusgul | 72771 | 3.4% |
| Coalmar | 61526 | 2.9% |
| Lorgulgus | 56432 | 2.7% |
| Nabargus | 54921 | 2.6% |
| Alfrusma | 54086 | 2.6% |
| Other values (19) | 311023 |
Length
| Value | Count | Frequency (%) |
| alloralf | 691507 | |
| magornmar | 554462 | |
| lorvalmo | 92626 | 4.4% |
| thrilvallor | 90364 | 4.3% |
| erodmo | 77317 | 3.7% |
| egusgul | 72771 | 3.4% |
| coalmar | 61526 | 2.9% |
| lorgulgus | 56432 | 2.7% |
| nabargus | 54921 | 2.6% |
| alfrusma | 54086 | 2.6% |
| Other values (19) | 311023 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 310 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 170.3 MiB |
| Enlightened Dark Empire | |
|---|---|
| Evil Chocolate Rock | 79646 |
| First Salmon Rock | 67596 |
| Purple Creek | 66267 |
| Long Lavender Butter | 55443 |
| Other values (305) |
Length
| Max length | 28 |
|---|---|
| Median length | 20 |
| Mean length | 19.32658411 |
| Min length | 5 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | First Salmon Rock |
|---|---|
| 2nd row | Enlightened Dark Empire |
| 3rd row | Enlightened Dark Empire |
| 4th row | Long Lavender Butter |
| 5th row | First Salmon Rock |
Common Values
| Value | Count | Frequency (%) |
| Enlightened Dark Empire | 513610 | |
| Evil Chocolate Rock | 79646 | 3.8% |
| First Salmon Rock | 67596 | 3.2% |
| Purple Creek | 66267 | 3.1% |
| Long Lavender Butter | 55443 | 2.6% |
| Last Pink River | 54959 | 2.6% |
| Horrible Chartreuse Mud | 51515 | 2.4% |
| Rare Lemon Key | 44927 | 2.1% |
| Clean Aqua Soil | 40750 | 1.9% |
| Angry Navy Empire | 40639 | 1.9% |
| Other values (300) | 1101683 |
Length
| Value | Count | Frequency (%) |
| empire | 596058 | 9.5% |
| dark | 534725 | 8.5% |
| enlightened | 528657 | 8.4% |
| rock | 193255 | 3.1% |
| evil | 171744 | 2.7% |
| chocolate | 170371 | 2.7% |
| purple | 109814 | 1.7% |
| tree | 105747 | 1.7% |
| first | 99264 | 1.6% |
| long | 96855 | 1.5% |
| Other values (107) | 3680619 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 153.4 MiB |
| proveedor_2 | |
|---|---|
| proveedor_1 |
Length
| Max length | 11 |
|---|---|
| Median length | 11 |
| Mean length | 11 |
| Min length | 11 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | proveedor_2 |
|---|---|
| 2nd row | proveedor_2 |
| 3rd row | proveedor_2 |
| 4th row | proveedor_2 |
| 5th row | proveedor_2 |
Common Values
| Value | Count | Frequency (%) |
| proveedor_2 | 1917950 | |
| proveedor_1 | 199085 | 9.4% |
Length
Pie chart
| Value | Count | Frequency (%) |
| proveedor_2 | 1917950 | |
| proveedor_1 | 199085 | 9.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 134.9 MiB |
| IV | |
|---|---|
| V | |
| III | |
| VI | |
| II |
Length
| Max length | 3 |
|---|---|
| Median length | 2 |
| Mean length | 1.837347517 |
| Min length | 1 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | IV |
|---|---|
| 2nd row | V |
| 3rd row | V |
| 4th row | IV |
| 5th row | IV |
Common Values
| Value | Count | Frequency (%) |
| IV | 1037575 | |
| V | 554462 | |
| III | 214383 | 10.1% |
| VI | 186672 | 8.8% |
| II | 119681 | 5.7% |
| I | 4262 | 0.2% |
Length
Pie chart
| Value | Count | Frequency (%) |
| iv | 1037575 | |
| v | 554462 | |
| iii | 214383 | 10.1% |
| vi | 186672 | 8.8% |
| ii | 119681 | 5.7% |
| i | 4262 | 0.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 34 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4525981.968 |
| Minimum | 4220015 |
|---|---|
| Maximum | 4829827 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 32.3 MiB |
Quantile statistics
| Minimum | 4220015 |
|---|---|
| 5-th percentile | 4230022 |
| Q1 | 4351043 |
| median | 4533931 |
| Q3 | 4739414 |
| 95-th percentile | 4809797 |
| Maximum | 4829827 |
| Range | 609812 |
| Interquartile range (IQR) | 388371 |
Descriptive statistics
| Standard deviation | 204325.5328 |
|---|---|
| Coefficient of variation (CV) | 0.04514501699 |
| Kurtosis | -1.399950746 |
| Mean | 4525981.968 |
| Median Absolute Deviation (MAD) | 182888 |
| Skewness | -0.03917794757 |
| Sum | 9.581662236 × 1012 |
| Variance | 4.174892337 × 1010 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 4769520 | 139132 | 6.6% |
| 4230022 | 129366 | 6.1% |
| 4351043 | 127350 | 6.0% |
| 4779537 | 119365 | 5.6% |
| 4789544 | 99068 | 4.7% |
| 4330800 | 97645 | 4.6% |
| 4533931 | 97260 | 4.6% |
| 4240039 | 97197 | 4.6% |
| 4250046 | 93645 | 4.4% |
| 4554143 | 92176 | 4.4% |
| Other values (24) | 1024831 |
| Value | Count | Frequency (%) |
| 4220015 | 57553 | |
| 4230022 | 129366 | |
| 4240039 | 97197 | |
| 4250046 | 93645 | |
| 4260053 | 8939 | 0.4% |
| 4330800 | 97645 | |
| 4351043 | 127350 | |
| 4361050 | 79798 | |
| 4381425 | 90842 | |
| 4422187 | 19356 | 0.9% |
| Value | Count | Frequency (%) |
| 4829827 | 27367 | 1.3% |
| 4819810 | 53972 | 2.5% |
| 4809797 | 84737 | |
| 4789544 | 99068 | |
| 4779537 | 119365 | |
| 4769520 | 139132 | |
| 4749421 | 2987 | 0.1% |
| 4739414 | 2752 | 0.1% |
| 4729193 | 16665 | 0.8% |
| 4719179 | 3264 | 0.2% |
| Distinct | 34 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 178.6 MiB |
| Cornflakes Chocolate Choc Chip | 139132 |
|---|---|
| Crunch Life Chocolate | 129366 |
| Graham Mango Peach | 127350 |
| Crunchy Bran Chocolate Choc Chip | 119365 |
| Crunchy Nut Cornflakes Chocolate Choc Chip | 99068 |
| Other values (29) |
Length
| Max length | 42 |
|---|---|
| Median length | 22 |
| Mean length | 23.46612786 |
| Min length | 15 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Muesli Chocolate |
|---|---|
| 2nd row | Cups Mango Peach |
| 3rd row | Fruit & Nut Chocolate Choc Chip |
| 4th row | Graham Mango Peach |
| 5th row | Crunch Berries Mango Peach |
Common Values
| Value | Count | Frequency (%) |
| Cornflakes Chocolate Choc Chip | 139132 | 6.6% |
| Crunch Life Chocolate | 129366 | 6.1% |
| Graham Mango Peach | 127350 | 6.0% |
| Crunchy Bran Chocolate Choc Chip | 119365 | 5.6% |
| Crunchy Nut Cornflakes Chocolate Choc Chip | 99068 | 4.7% |
| Crunch Mango Peach | 97645 | 4.6% |
| Cups Mango Peach | 97260 | 4.6% |
| Lucjy Charms Chocolate | 97197 | 4.6% |
| Muesli Chocolate | 93645 | 4.4% |
| Stars Mango Peach | 92176 | 4.4% |
| Other values (24) | 1024831 |
Length
| Value | Count | Frequency (%) |
| chocolate | 1136530 | |
| mango | 980505 | |
| peach | 980505 | |
| choc | 749830 | |
| chip | 749830 | |
| crunch | 318919 | 4.1% |
| crunchy | 295491 | 3.8% |
| bran | 281160 | 3.6% |
| cornflakes | 252655 | 3.3% |
| lucjy | 153795 | 2.0% |
| Other values (28) | 1865012 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 153.7 MiB |
| Sugar-free | |
|---|---|
| Super-flavour |
Length
| Max length | 13 |
|---|---|
| Median length | 10 |
| Mean length | 11.11669009 |
| Min length | 10 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Sugar-free |
|---|---|
| 2nd row | Super-flavour |
| 3rd row | Sugar-free |
| 4th row | Sugar-free |
| 5th row | Sugar-free |
Common Values
| Value | Count | Frequency (%) |
| Sugar-free | 1329011 | |
| Super-flavour | 788024 |
Length
Pie chart
| Value | Count | Frequency (%) |
| sugar-free | 1329011 | |
| super-flavour | 788024 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 152.7 MiB |
| Cereal bars | |
|---|---|
| Cereal box |
Length
| Max length | 11 |
|---|---|
| Median length | 11 |
| Mean length | 10.62776997 |
| Min length | 10 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Cereal bars |
|---|---|
| 2nd row | Cereal box |
| 3rd row | Cereal bars |
| 4th row | Cereal bars |
| 5th row | Cereal bars |
Common Values
| Value | Count | Frequency (%) |
| Cereal bars | 1329011 | |
| Cereal box | 788024 |
Length
Pie chart
| Value | Count | Frequency (%) |
| cereal | 2117035 | |
| bars | 1329011 | |
| box | 788024 | 18.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 822 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 32.81549543 |
| Minimum | 0.2 |
|---|---|
| Maximum | 172 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 32.3 MiB |
Quantile statistics
| Minimum | 0.2 |
|---|---|
| 5-th percentile | 2.7 |
| Q1 | 10 |
| median | 20 |
| Q3 | 45.36 |
| 95-th percentile | 120 |
| Maximum | 172 |
| Range | 171.8 |
| Interquartile range (IQR) | 35.36 |
Descriptive statistics
| Standard deviation | 35.03071821 |
|---|---|
| Coefficient of variation (CV) | 1.067505389 |
| Kurtosis | 2.584247665 |
| Mean | 32.81549543 |
| Median Absolute Deviation (MAD) | 13.25 |
| Skewness | 1.736329198 |
| Sum | 69471552.37 |
| Variance | 1227.151218 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 10.8 | 171931 | 8.1% |
| 12 | 125606 | 5.9% |
| 24 | 121115 | 5.7% |
| 4.8 | 112482 | 5.3% |
| 6.75 | 106746 | 5.0% |
| 60 | 85394 | 4.0% |
| 21.6 | 70503 | 3.3% |
| 20 | 70028 | 3.3% |
| 36 | 69455 | 3.3% |
| 48 | 69374 | 3.3% |
| Other values (812) | 1114401 |
| Value | Count | Frequency (%) |
| 0.2 | 658 | < 0.1% |
| 0.25 | 20 | < 0.1% |
| 0.4 | 2414 | |
| 0.45 | 556 | < 0.1% |
| 0.5 | 6 | < 0.1% |
| 0.6 | 1720 | |
| 0.75 | 6 | < 0.1% |
| 0.8 | 2024 | |
| 0.9 | 2617 | |
| 1 | 2016 |
| Value | Count | Frequency (%) |
| 172 | 21 | < 0.1% |
| 171 | 15 | < 0.1% |
| 170.1 | 1051 | < 0.1% |
| 170 | 12 | < 0.1% |
| 169 | 14 | < 0.1% |
| 168.75 | 7 | < 0.1% |
| 168.21 | 29 | < 0.1% |
| 168 | 10294 | |
| 167 | 48 | < 0.1% |
| 166.32 | 143 | < 0.1% |
| Distinct | 231 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 23.37807589 |
| Minimum | 10.97 |
|---|---|
| Maximum | 47.8 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 32.3 MiB |
Quantile statistics
| Minimum | 10.97 |
|---|---|
| 5-th percentile | 12.67 |
| Q1 | 13.74 |
| median | 15.08 |
| Q3 | 36.23 |
| 95-th percentile | 42.14 |
| Maximum | 47.8 |
| Range | 36.83 |
| Interquartile range (IQR) | 22.49 |
Descriptive statistics
| Standard deviation | 11.79541157 |
|---|---|
| Coefficient of variation (CV) | 0.5045501444 |
| Kurtosis | -1.514331558 |
| Mean | 23.37807589 |
| Median Absolute Deviation (MAD) | 2.94 |
| Skewness | 0.5524296635 |
| Sum | 49492204.89 |
| Variance | 139.131734 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 18.37 | 70410 | 3.3% |
| 19.6 | 59446 | 2.8% |
| 36.23 | 48205 | 2.3% |
| 13.39 | 47212 | 2.2% |
| 13.12 | 46290 | 2.2% |
| 12.86 | 43829 | 2.1% |
| 35.54 | 40200 | 1.9% |
| 36.06 | 39858 | 1.9% |
| 13.84 | 39587 | 1.9% |
| 13.55 | 37771 | 1.8% |
| Other values (221) | 1644227 |
| Value | Count | Frequency (%) |
| 10.97 | 14084 | |
| 11.09 | 20298 | |
| 11.19 | 4956 | 0.2% |
| 11.31 | 6629 | 0.3% |
| 11.4 | 10846 | |
| 11.54 | 1965 | 0.1% |
| 11.6 | 13 | < 0.1% |
| 11.62 | 5166 | 0.2% |
| 11.79 | 6 | < 0.1% |
| 11.82 | 8295 |
| Value | Count | Frequency (%) |
| 47.8 | 1796 | |
| 47.35 | 630 | < 0.1% |
| 46.96 | 312 | < 0.1% |
| 46.9 | 2 | < 0.1% |
| 46.84 | 1924 | |
| 46.7 | 323 | < 0.1% |
| 46.4 | 1 | < 0.1% |
| 46.36 | 750 | < 0.1% |
| 45.47 | 1 | < 0.1% |
| 45.24 | 2487 |
| Distinct | 366 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 16.96744954 |
| Minimum | 5.4 |
|---|---|
| Maximum | 39.15 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 32.3 MiB |
Quantile statistics
| Minimum | 5.4 |
|---|---|
| 5-th percentile | 7.09 |
| Q1 | 9.67 |
| median | 10.62 |
| Q3 | 27.28 |
| 95-th percentile | 32.78 |
| Maximum | 39.15 |
| Range | 33.75 |
| Interquartile range (IQR) | 17.61 |
Descriptive statistics
| Standard deviation | 9.370304831 |
|---|---|
| Coefficient of variation (CV) | 0.5522518167 |
| Kurtosis | -1.333476509 |
| Mean | 16.96744954 |
| Median Absolute Deviation (MAD) | 1.86 |
| Skewness | 0.6072504708 |
| Sum | 35920684.53 |
| Variance | 87.80261263 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 12.64 | 48447 | 2.3% |
| 9.49 | 39587 | 1.9% |
| 10.17 | 35512 | 1.7% |
| 13.64 | 34380 | 1.6% |
| 9.56 | 32877 | 1.6% |
| 9.84 | 32501 | 1.5% |
| 9.67 | 30277 | 1.4% |
| 27.18 | 29576 | 1.4% |
| 10 | 27717 | 1.3% |
| 9.29 | 26761 | 1.3% |
| Other values (356) | 1779400 |
| Value | Count | Frequency (%) |
| 5.4 | 14084 | |
| 5.51 | 20298 | |
| 5.55 | 5609 | 0.3% |
| 5.62 | 4956 | 0.2% |
| 5.73 | 6629 | 0.3% |
| 5.75 | 13 | < 0.1% |
| 5.78 | 2565 | 0.1% |
| 5.82 | 5237 | 0.2% |
| 5.94 | 6 | < 0.1% |
| 5.96 | 846 | < 0.1% |
| Value | Count | Frequency (%) |
| 39.15 | 312 | < 0.1% |
| 39.04 | 1924 | |
| 38.55 | 750 | < 0.1% |
| 38.22 | 1796 | |
| 37.77 | 630 | < 0.1% |
| 37.66 | 1 | < 0.1% |
| 37.32 | 2 | < 0.1% |
| 37.12 | 323 | < 0.1% |
| 36.82 | 1 | < 0.1% |
| 36.8 | 675 | < 0.1% |
| Distinct | 10633 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 595.3688936 |
| Minimum | 4.505 |
|---|---|
| Maximum | 3083.13 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 32.3 MiB |
Quantile statistics
| Minimum | 4.505 |
|---|---|
| 5-th percentile | 87.624 |
| Q1 | 190.416 |
| median | 394.956 |
| Q3 | 814.104 |
| 95-th percentile | 1826.88 |
| Maximum | 3083.13 |
| Range | 3078.625 |
| Interquartile range (IQR) | 623.688 |
Descriptive statistics
| Standard deviation | 556.1532946 |
|---|---|
| Coefficient of variation (CV) | 0.9341322675 |
| Kurtosis | 2.090083149 |
| Mean | 595.3688936 |
| Median Absolute Deviation (MAD) | 228.876 |
| Skewness | 1.576944355 |
| Sum | 1260416786 |
| Variance | 309306.4871 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 123.9975 | 29716 | 1.4% |
| 132.3 | 28268 | 1.3% |
| 173.904 | 20806 | 1.0% |
| 389.448 | 16004 | 0.8% |
| 386.316 | 15852 | 0.7% |
| 247.995 | 15548 | 0.7% |
| 264.6 | 14144 | 0.7% |
| 407.052 | 13650 | 0.6% |
| 178.656 | 13435 | 0.6% |
| 267.8 | 12900 | 0.6% |
| Other values (10623) | 1936712 |
| Value | Count | Frequency (%) |
| 4.505 | 1 | < 0.1% |
| 4.5925 | 8 | < 0.1% |
| 4.73 | 2 | < 0.1% |
| 4.9 | 5 | < 0.1% |
| 7.108 | 58 | |
| 7.246 | 24 | < 0.1% |
| 7.2775 | 3 | < 0.1% |
| 7.302 | 8 | < 0.1% |
| 7.444 | 14 | < 0.1% |
| 7.548 | 113 |
| Value | Count | Frequency (%) |
| 3083.13 | 2 | < 0.1% |
| 3082.9005 | 4 | |
| 3078.387 | 1 | < 0.1% |
| 3078 | 7 | |
| 3075.246 | 1 | < 0.1% |
| 3073.44 | 1 | < 0.1% |
| 3073.428 | 3 | |
| 3072.304 | 1 | < 0.1% |
| 3072.006 | 4 | |
| 3071.709 | 1 | < 0.1% |
| Distinct | 14531 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 423.6205214 |
| Minimum | 3.0725 |
|---|---|
| Maximum | 2529.792 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 32.3 MiB |
Quantile statistics
| Minimum | 3.0725 |
|---|---|
| 5-th percentile | 63.576 |
| Q1 | 133.65 |
| median | 289.575 |
| Q3 | 583.8 |
| 95-th percentile | 1301.52 |
| Maximum | 2529.792 |
| Range | 2526.7195 |
| Interquartile range (IQR) | 450.15 |
Descriptive statistics
| Standard deviation | 402.4650316 |
|---|---|
| Coefficient of variation (CV) | 0.950060281 |
| Kurtosis | 2.826570142 |
| Mean | 423.6205214 |
| Median Absolute Deviation (MAD) | 173.535 |
| Skewness | 1.699498889 |
| Sum | 896819470.6 |
| Variance | 161978.1017 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 85.32 | 19095 | 0.9% |
| 92.07 | 16462 | 0.8% |
| 311.58 | 13650 | 0.6% |
| 130.944 | 13435 | 0.6% |
| 113.04 | 12360 | 0.6% |
| 170.64 | 10853 | 0.5% |
| 265.032 | 9821 | 0.5% |
| 82.9575 | 9788 | 0.5% |
| 113.88 | 9111 | 0.4% |
| 227.76 | 8666 | 0.4% |
| Other values (14521) | 1993794 |
| Value | Count | Frequency (%) |
| 3.0725 | 1 | < 0.1% |
| 3.1125 | 1 | < 0.1% |
| 3.12 | 1 | < 0.1% |
| 3.16 | 6 | < 0.1% |
| 3.2475 | 2 | < 0.1% |
| 3.41 | 4 | < 0.1% |
| 3.4275 | 1 | < 0.1% |
| 4.572 | 38 | |
| 4.71 | 11 | < 0.1% |
| 4.95 | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 2529.792 | 3 | < 0.1% |
| 2525.04 | 22 | < 0.1% |
| 2524.32 | 7 | < 0.1% |
| 2517.12 | 11 | < 0.1% |
| 2498.04 | 2 | < 0.1% |
| 2496.312 | 16 | < 0.1% |
| 2492.766 | 2 | < 0.1% |
| 2485.656 | 7 | < 0.1% |
| 2478.168 | 253 | |
| 2472.876 | 22 | < 0.1% |
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.First rows
| id | date | store_id | format | store_name | structure | division | deposit/distributor | state | municipality/city | supplier | grade | sku | sku_description | sku_category | sku_subcategory | units | unit_price | unit_margin | total | total_margin | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0 | 2016-01-02 | 1292 | Grocery | Bizarre Salmon Market | FORANEO | BAJÍO | Argule Ifonforge Industries | Lorvalmo | First Salmon Rock | proveedor_2 | IV | 4250046 | Muesli Chocolate | Sugar-free | Cereal bars | 12.00 | 13.88 | 9.59 | 166.5600 | 115.0800 |
| 1 | 1 | 2016-01-02 | 2466 | Leftorium | Young Khaki TallMarket | METRO | METRO-NORTE | Emolor Vocals | Magornmar | Enlightened Dark Empire | proveedor_2 | V | 4533931 | Cups Mango Peach | Super-flavour | Cereal box | 43.20 | 36.06 | 24.54 | 1557.7920 | 1060.1280 |
| 2 | 2 | 2016-01-02 | 1460 | Leftorium | Big Salmon Deli | METRO | METRO-SUR | Thrilthoal Empire | Magornmar | Enlightened Dark Empire | proveedor_2 | V | 4819810 | Fruit & Nut Chocolate Choc Chip | Sugar-free | Cereal bars | 27.00 | 19.60 | 13.64 | 529.2000 | 368.2800 |
| 3 | 4 | 2016-01-02 | 3543 | Grocery | Bad Crimson Shop | METRO | METRO-NORTE | Lorthogus Toughworks | Alloralf | Long Lavender Butter | proveedor_2 | IV | 4351043 | Graham Mango Peach | Sugar-free | Cereal bars | 17.01 | 13.18 | 9.67 | 224.1918 | 164.4867 |
| 4 | 5 | 2016-01-02 | 3586 | Leftorium | Kicking Lemon LunchHall | FORANEO | BAJÍO | Argule Ifonforge Industries | Lorvalmo | First Salmon Rock | proveedor_2 | IV | 4422187 | Crunch Berries Mango Peach | Sugar-free | Cereal bars | 13.50 | 18.37 | 12.48 | 247.9950 | 168.4800 |
| 5 | 8 | 2016-01-02 | 2951 | AllInOne | Alive Azure Center | FORANEO | SURESTE | Eioval Aerospace | Coalmar | Rare Orange Applepie | proveedor_2 | VI | 4554143 | Stars Mango Peach | Sugar-free | Cereal bars | 12.00 | 14.19 | 9.84 | 170.2800 | 118.0800 |
| 6 | 9 | 2016-01-02 | 2666 | AllInOne | Awesome Silver Cafe | FORANEO | CENTRO-SUR | Erodmad Industrail | Egusgul | Dead Orange Ship | proveedor_2 | IV | 4533931 | Cups Mango Peach | Super-flavour | Cereal box | 21.60 | 36.06 | 24.54 | 778.8960 | 530.0640 |
| 7 | 10 | 2016-01-02 | 2219 | Leftorium | Funny Pink Jeweller | METRO | METRO-NORTE | Ioarco Corp. | Alloralf | Tiny Chocolate River | proveedor_2 | IV | 4789544 | Crunchy Nut Cornflakes Chocolate Choc Chip | Super-flavour | Cereal box | 43.20 | 35.77 | 28.77 | 1545.2640 | 1242.8640 |
| 8 | 11 | 2016-01-02 | 3798 | AllInOne | Enlightened Green Fishmonger | METRO | METRO-NORTE | Emolor Vocals | Alloralf | Last Pink River | proveedor_2 | IV | 4665676 | Crunch Chocolate Choc Chip | Super-flavour | Cereal box | 32.40 | 37.69 | 28.85 | 1221.1560 | 934.7400 |
| 9 | 13 | 2016-01-02 | 3799 | AllInOne | Enlightened Olive Florist | METRO | METRO-SUR | Thrilvitar Industrail | Magornmar | Enlightened Dark Empire | proveedor_2 | V | 4665676 | Crunch Chocolate Choc Chip | Super-flavour | Cereal box | 54.00 | 37.69 | 28.85 | 2035.2600 | 1557.9000 |
Last rows
| id | date | store_id | format | store_name | structure | division | deposit/distributor | state | municipality/city | supplier | grade | sku | sku_description | sku_category | sku_subcategory | units | unit_price | unit_margin | total | total_margin | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2117025 | 2501718 | 2017-12-05 | 2591 | AllInOne | Cyan BigCom | FORANEO | SURESTE | Malormad Corp. | Thogulgul | Awesome Blue City | proveedor_2 | II | 4809797 | Fruit & Bran Chocolate Choc Chip | Sugar-free | Cereal bars | 6.75 | 19.29 | 13.36 | 130.2075 | 90.18 |
| 2117026 | 2501719 | 2017-12-05 | 1008 | AllInOne | Dangerous Pink Stationer | DISTRIBUIDORES | CENTRO | Movitalf Empire | Alloralf | Long Chocolate Barrier | proveedor_2 | IV | 4250046 | Muesli Chocolate | Sugar-free | Cereal bars | 48.00 | 15.17 | 10.66 | 728.1600 | 511.68 |
| 2117027 | 2501720 | 2017-12-05 | 1653 | Grocery | Tiny Silver GreatShop | DISTRIBUIDORES | BAJÍO | Rusloralf Inc. | Erodmo | Angry Fuchsia Bay | proveedor_2 | III | 4769520 | Cornflakes Chocolate Choc Chip | Super-flavour | Cereal box | 1.60 | 42.58 | 32.55 | 68.1280 | 52.08 |
| 2117028 | 2501722 | 2017-12-05 | 2159 | Grocery | Legendary Magenta Butcher | DISTRIBUIDORES | CENTRO | Movitalf Empire | Alloralf | Long Chocolate Barrier | proveedor_2 | IV | 4230022 | Crunch Life Chocolate | Sugar-free | Cereal bars | 10.00 | 13.88 | 9.81 | 138.8000 | 98.10 |
| 2117029 | 2501723 | 2017-12-05 | 240 | Shop | Dull Navy BookShop | METRO | METRO-SUR | Thrilthoal Empire | Alloralf | Rare Lemon Key | proveedor_1 | IV | 4543948 | Puffs Mango Peach | Super-flavour | Cereal box | 5.40 | 43.25 | 31.90 | 233.5500 | 172.26 |
| 2117030 | 2501724 | 2017-12-05 | 1672 | Grocery | Awful Red Convenience | METRO | METRO-SUR | Ioalfio Ifonforge Industries | Magornmar | Enlightened Dark Empire | proveedor_2 | V | 4769520 | Cornflakes Chocolate Choc Chip | Super-flavour | Cereal box | 14.40 | 42.58 | 32.55 | 613.1520 | 468.72 |
| 2117031 | 2501725 | 2017-12-05 | 1075 | GipsyTrade | Kicking Navy Florist | FORANEO | CENTRO | Elortho Aerospace | Alloralf | Awful Beige | proveedor_2 | IV | 4789544 | Crunchy Nut Cornflakes Chocolate Choc Chip | Super-flavour | Cereal box | 13.50 | 42.75 | 35.06 | 577.1250 | 473.31 |
| 2117032 | 2501726 | 2017-12-05 | 3995 | Grocery | Empty Sky Blue GipsyTrade | FORANEO | CENTRO-SUR | Gorngusco Toughworks | Lorgulgus | Horrible Purple Tree | proveedor_2 | IV | 4442378 | Crunchy Bran Mango Peach | Sugar-free | Cereal bars | 156.00 | 11.82 | 5.98 | 1843.9200 | 932.88 |
| 2117033 | 2501728 | 2017-12-05 | 2708 | Grocery | Long Chartreuse Stationer | METRO | METRO-SUR | Thrilthoal Empire | Magornmar | Enlightened Dark Empire | proveedor_2 | V | 4330800 | Crunch Mango Peach | Sugar-free | Cereal bars | 24.00 | 14.88 | 10.02 | 357.1200 | 240.48 |
| 2117034 | 2501729 | 2017-12-05 | 1779 | Grocery | Funny Sea Green AllInOne | METRO | METRO-SUR | Barmaralf Inc. | Alloralf | New Aqua Jungle | proveedor_2 | IV | 4230022 | Crunch Life Chocolate | Sugar-free | Cereal bars | 16.00 | 13.88 | 9.81 | 222.0800 | 156.96 |